CREATE PROCEDURE [dbo].[asi_PurgeExpiredAnonymousCarts]
AS
BEGIN

    SET NOCOUNT ON

    -- calculate the purge date
    DECLARE @purgeDate datetime
    SET @purgeDate = DATEADD(DAY,-15,GETUTCDATE())

    -- delete Carts that only have a CreatedOn date
    DELETE
      FROM [dbo].[Cart]
     WHERE [CreatedOn] <= @purgeDate
           AND [UserId] = 'anonymous'
           AND [UpdatedOn] IS NULL

    -- delete Carts that have an UpdatedOn date
    DELETE
      FROM [dbo].[Cart]
     WHERE [UpdatedOn] <= @purgeDate
           AND [UserId] = 'anonymous'

END


GO